﻿CREATE TABLE [dbo].[TravelExpense] (
    [Id]                    UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [TravelAuthorizationId] UNIQUEIDENTIFIER NOT NULL,
    [ExpenseDescription]    NTEXT            NULL,
    [TotalCost]             MONEY            NOT NULL,
    [AdvanceRequired]       MONEY            NULL,
    [CurrencyId]            UNIQUEIDENTIFIER NULL,
    [BudgetLineId]          UNIQUEIDENTIFIER NULL
);

